package com.myteam.fugaocrm.sqldb.mapper;

import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.myteam.fugaocrm.modle.FgTask;

/**
 * 任务Mapper
 * @author BZX
 */
public interface FgTaskMapper {
	/** 查询全部未删除的任务 */
	@Select("SELECT * FROM fg_task WHERE is_delete = 0")
	public List<FgTask> all();
	
	/** 修改售前日志任务时间，用来标记删除上一天的提醒 */
	@Select("update fg_task SET last_time = #{date} WHERE task_id = 1")
	public void updateLogTime(@Param("date") Date date);
}
